home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr09
/
fgrtodb.zip
/
READ.ME
< prev
next >
Wrap
Text File
|
1993-06-03
|
2KB
|
53 lines
The following describes how to convert Family Group Records into delimited
files that can be loaded into dBASE III+.
Files included:
READ.ME -- this file
FGR_TO.D.TXT -- a text file explaining how to convert FGR
SAMPLE.FGR -- sample family group record
To extract husband and wife data from FGRs:
PAF.SED -- the sed file that cleans up the FGR
PAF.AWK -- the awk program file that extracts and formats the data from
the FGRs.
PARENTS.TXT -- the sample FGR after being processed by sed
PARENTS.DB -- the delimited file for input into dbase
To extract unmarried children from FGRs:
PAF1.SED -- the sed file that cleans up the FGR
CHILD.TXT -- the sample FGR after being processed by sed
PAF1.AWK -- the awk program file that extracts and formats the data from
the FGRs.
CHILD.1ST -- the delimited file produced by paf1.awk
CLEANUP.SED -- the sed file to clean up the delimited file
CHILD.DB -- the delimited file for input into dbase
The structure of the dBASE file that I used is as follows:
Field Field Name Type Width Dec
1 PERSON Character 30 # Individual
2 SEX Character 1 # Individual's sex
3 RIN Numeric 4 # Individual's RIN
4 BIRTHDATE Character 20 # Individual's birthdate
5 BIRTHPLACE Character 30 # Individual's birthplace
6 SPOUSE Character 30 # Individual's spouse
7 SRIN Numeric 4 # Spouse's RIN
8 MARRDATE Character 20 # Date of marriage
9 MARRPLACE Character 30 # Marriage location
10 MRIN Numeric 4 # MRIN
11 DEATH Character 20 # Date of death
12 DEATHPLACE Character 30 # Location of death
13 FATHER Character 30 # Father
14 F_RIN Numeric 4 # Father's RIN
15 MOTHER Character 30 # Mother
16 M_RIN Numeric 4 # Mother's RIN
17 PMRIN Numeric 4 # Parent's MRIN
**Total ** 296
Stephen Valentine
8313 Bound Brook Lane
Alexandria, VA 22309